Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is there any way to get the hours shown in progress bar of story WI in report ???

Questions
Tags
Users
Badges
Akash Kaanholkar
(20●2●3●6) Jan 10 '23, 11:33 p.m.
I was trying to build report using jazz report builder which will show us the actual time spent on story shown in the progress bar of story work item .

I tried so much but i am not getting that ....

So if anyone knows about this then please do let me know

0 votes

3 answers
1,200 views
0 votes

Accepted answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Jan 11 '23, 2:53 a.m.

 As far as I can tell from the process specification the data you are talking about is not available as attribute. The presentation named Work Progress is a so called non attribute based presentation. The data is calculated by the work item UI and likely also the planning UI. 


Since it is not available as attribute, I doubt it will be available in the reporting components. 

I have not tried to access the data using the Java APIs. It might be possible to get that data, but it is not obvious how to. I have written this extension that aggregates such information in an attribute: https://rsjazz.wordpress.com/2012/07/31/rtc-update-parent-duration-estimation-and-effort-participant/ . As a disclaimer, I don't think this is a particularly nice solution. 

If someone else has more knowledge about this, please help.

Akash Kaanholkar selected this answer as the correct answer

1 vote

Comments
Akash Kaanholkar
Jan 11 '23, 3:01 a.m.
Ok Ralph.

And thank you for this help

2 other answers

Permanent link
Jackie Albert
(1.6k●1●49●47) Jan 11 '23, 8:09 a.m.

This is not available to query or in the API's - it is something dynamically calculated in the UI.  However, this means you could also do the same dynamic calculation in Report Builder.

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 11 '23, 9:06 a.m.

The calculation works on all child work items, where the child relationship is within the project area. The calculation includes all execution items that have execution data.

The calculation is based on the time spent or time remaining (uses the same attribute). The effort is calculated based on time spent or time remaining versus the estimate or the corrected estimate which is used if set. 

Permanent link
Akash Kaanholkar
(20●2●3●6) Jan 11 '23, 11:24 p.m.
Thank you to both Jackie and Ralph. I was trying to  calculate this  data in the progress bar by summing up the all child work item in the Story . I don't know why ,but I am not getting what i want.

Even I used that calculated value and custom expression too so that I can get then actual time spent on story  but summing up of all child in story is also not seems to be possible with the present attributes and functions.

So both of you can you please tell me that the way I am going for is right or I have to go for something else.

Is this calculation really possible with present attributes and functions or Its something complex one, if it is then can you please suggest me something which will give me solution for this.


0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 12 '23, 8:50 a.m.

The attributes involved are  


  • Corrected Estimate id: correctedEstimate
  • Estimate id: duration
  • Time Spent id: timeSpent
See https://jazz.net/forum/questions/275943/what-is-the-logic-behind-calculating-time-spent-attribute-in-rtc/275963 for some comment on the logic.


Akash Kaanholkar
Jan 13 '23, 1:18 a.m.
Thank you Ralph.

And One thing that I was trying to apply condition over report of 'Attachments', but it seems we can not able to use 'Attachments' in conditions as well as in column of reports.

Is it ???

Can you please tell me something about this.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jan 13 '23, 3:50 a.m.

I do not know how this would be related to the question here. Please ask another question with reasonable details.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jan 10 '23, 11:33 p.m.

Question was seen: 1,200 times

Last updated: Jan 13 '23, 3:50 a.m.

Related questions
Confirmation Cancel Confirm